Excel Talk is an add-in for Microsoft Excel which lets Excel read aloud from your spreadsheet using any of the voices installed on your Macintosh under the Apple Speech Manager.
Features
--------
• Multiple selections are handled correctly.
• The Speech Manager is given the formatted contents of each cell rather than the
underlying numbers, so that currency and percentage formatting is spoken correctly.
• The speed, pitch and level of modulation of each voice can be controlled by the user.
• Speech can be generated from the Excel macro language.
Requirements
------------
Excel Talk obviously requires the Speech Manager (available from Apple and over the internet at ftp.apple.com) and at least version 4.0 of Microsoft Excel. You should also be aware that the higher quality PlainTalk™ voices require a lot of memory to run. All Macintoshes should be able to run the basic Speech Manager voices with no problems.
I only tested Excel Talk under System 7.1: however, it should run under all versions of System 7.
NB the Speech Manager takes its memory from the System heap, not from Excel, so if Excel Talk tells you there is not enough memory to use a voice, increasing Excel’s memory allocation will actually make things worse. I find simply choosing the “Hide Others” command from the Application menu often helps. Failing that, quit your most recently launched applications to allow the System heap room to grow.
How to install
------------
• Put the Speech Manager and any additional voices you may have in your System folder
or Extensions folder.
• If you want Excel Talk to open automatically, put it in your Excel Startup Folder (you
could also put it somewhere else and install it with the Add-in Manager, but frankly
the Add-in Manager on the Mac is just too slow for words).
• If you don’t want Excel Talk hanging around all the time, put it anywhere you like (eg
your Macro Library or Apple Menu Items folder) and open it (with double-clicking, the
File Open command or any other voodoo your Mac has installed) whenever you need it.
How to use
----------
• Excel Talk creates a “Speech” menu to the right of the usual Excel menus. It has balloon
help and is fairly self-explanatory.
• Select a cell or cells and choose “Speak Active Cell” or “Speak Selection” from the
Speech menu to hear some speech. Escape or command-period will stop the speech.
The cell currently being spoken is shown in the status bar at the bottom of the
screen.
• The “Voices…” command lets you choose a different voice and change its rate, pitch
and modulation. The “Try Voice” button lets you try the voice out (click to stop the
test). If you are handy with ResEdit you can edit STR resource 131, which is the text
used.
• You can also change the voices by embedding commands in the spreadsheet. I’ve
included an example, which uses the [[pbase]] command to make Excel sing a scale
(it only really works with the Female PlainTalk™ voice). See Apple’s Speech Manager
documentation for more information about these commands.
• The “Show Speech Tool” command shows a tool which does the same thing as the
“Speak Selection” command. You can copy the tool to your main toolbar. Obviously it
will only work when Excel Talk is open.
• You can close Excel Talk from the Speech menu if you’re bored with it or it chews up
too much memory. You can always open it again later.
• Macro programmers can access the features of Excel Talk with the macro functions
SpeechHelp(), ChooseVoice(), ShowSpeechTool() and SpeechClose(). These live in a
category or their own, “Excel Talk”, at the bottom of the “Paste Function” dialogue box.
Development history
------------------
1.2.1 Maintenance release, a few internal improvements.
1.2 First public release. User choice of voices implemented.
1.1 Formatted contents of cell rather than underlying passed to Speech Manager.
1.0 Initial release.
Excel Talk was written in THINK C 5.0.4 using the Excel 4.0 Software Development Kit.
If anyone from Microsoft reads this, perhaps they could let me know when, if ever, they plan to honour their claim to support Excel SDK developers on CompuServe. I’m sure all the other lost souls in the PROGMSA forum will know what I mean.
There is a very similar add-in called ExcelTalk (no space) by John Blackburne. I wrote Excel Talk independently before I found out about this utility.
Excel Talk is freeware. Pass it around, but please always distribute this document with it.
Excel Talk is pretty robustly programmed, and has never crashed my machine, but you use it at your own risk.